<html>
<head>
	<title>Installing SQL Relay From Packages</title>
	<link rel="stylesheet" href="../css/styles.css">
</head>
<body>
<h1>Installing SQL Relay From Packages</h1>

<ul>
  <li><a href="#platforms">Supported Platforms</a></li>
  <li><a href="#linux">Linux</a></li>
  <li><a href="#freebsd">FreeBSD</a></li>
  <li><a href="#netbsd">NetBSD</a></li>
  <li><a href="#windows">Windows</a></li>
</ul>

<a name="platforms"/><h2>Supported Platforms</h2>

<p>SQL Relay packages are currently available for:</p>

<ul>
  <li>RPM-based Linux (Fedora, CentOS/RHEL, and OpenSuSE)</li>
  <li>FreeBSD</li>
  <li>NetBSD</li>
  <li>Windows</li>
</ul>

<p>Packages are not currently available for other platforms, but on other platforms, SQL Relay can be built from <a href="installing.html">source</a>.</p>

<a name="linux"/><h2>Linux</h2>

<p>SQL Relay packages are currently available for RPM-based Linux distributions like Fedora, CentOS/RHEL, and OpenSuSE Linux, for the x86_64 architecture.</p>

<p>Packages are not currenly available for dpkg-based Linux like Ubunutu and Debian Linux, or for non-x86_64 architectures.  On these platforms SQL Relay must be built from <a href="installing.html">source</a>.</p>

<p>To download the Linux packages, download the <a target="_blank" href="http://sourceforge.net/projects/sqlrelay/files/sqlrelay/2.0.0/sqlrelay-binary-distribution-2.0.0.tar.gz/download">SQL Relay Binary Distribution for Linux</a>.  This file is a tar.gz containing RPMs for all supported Linux platforms.</p>

<p>To install the packages, first extract the file:</p>

<blockquote>
  <pre>tar xfz sqlrelay-binary-distribution-2.0.0.tar.gz
</pre>

</blockquote>
<p>Then, change directories into the directory that was created during the extraction:</p>

<blockquote>
  <pre>cd sqlrelay-binary-distribution-2.0.0
</pre>

</blockquote>
<p>Then, change directories into the directory for the appropriate distribution.  For example:</p>

<blockquote>
  <pre>cd centos7x64
</pre>

</blockquote>
<p>Then, install the RPMs.  Since different platforms use different packaging systems, installation instructions depend on the platform.</p>

<blockquote>
  <p>On Fedora platforms, run (as root):</p>

  <blockquote>
    <pre>dnf localinstall *
</pre>

  </blockquote>
  <p>On CentOS platforms, run (as root):</p>

  <blockquote>
    <pre>yum localinstall *
</pre>

  </blockquote>
  <p>On OpenSuSE platforms, run (as root):</p>

  <blockquote>
    <pre>zypper install *
</pre>

  </blockquote>
</blockquote>
<p>In any case, the package packaging system should install the RPMs as well as any dependencies that they require.</p>

<p>Client libraries for most of the databases supported by SQL Relay are available as RPMs and should be automatically installed by the packaging system.  However, packages for commercial databases are not available from any standard package repository and must be installed manually for SQL Relay to actually work with these databases.</p>

<p>For SQL Relay to work with a commercial database, you must install and configure client libraries for one or more of <a target="_blank" href="http://www.oracle.com">Oracle</a>, <a target="_blank" href="http://scn.sap.com/community/developer-center/oltp-db">SAP/Sybase</a>, <a target="_blank" href="http://www.ibm.com/software/data/db2/">DB2</a>, or <a target="_blank" href="http://www.ibm.com/software/data/informix/">Informix</a>.</p>

<p>SQL Relay should now be installed.  At this point, it's safe to delete the sqlrelay-binary-distribution-2.0.0 directory and sqlrelay-binary-distribution-2.0.0.tar.gz file.</p>

<a name="freebsd"/><h2>FreeBSD</h2>

<p>SQL Relay is available as a <a target="_blank" href="http://www.freshports.org/databases/sqlrelay/">FreeBSD port</a>.  To install all packages related to SQL Relay, run (as root):</p>

<blockquote>
  <pre>pkg install sqlrelay py27-sqlrelay
</pre>

</blockquote>
<a name="netbsd"/><h2>NetBSD</h2>

<p>SQL Relay is available as a <a target="_blank" href="http://ftp.netbsd.org/pub/pkgsrc/current/pkgsrc/databases/sqlrelay/README.html">NetBSD</a> package. To install all available packages related to SQL Relay, run (as root):</p>

<blockquote>
  <pre>pkgin install sqlrelay sqlrelay-sqlite sqlrelay-pgsql sqlrelay-odbc sqlrelay-nodejs sqlrelay-mysql sqlrelay-freetds
ruby22-sqlrelay ruby21-sqlrelay ruby200-sqlrelay py27-sqlrelay php56-sqlrelay php55-sqlrelay p5-sqlrelay
</pre>

</blockquote>
<a name="windows"/><h2>Installing SQL Relay from Packages on Windows</h2>

<p>SQL Relay packages are currently available for Windows, for the x86 and x86_64 architectures.</p>

<p>To download the Windows packages, download the <a target="_blank" href="http://sourceforge.net/projects/sqlrelay/files/sqlrelay/2.0.0/sqlrelay-binary-distribution-2.0.0.zip/download">SQL Relay Binary Distribution for Windows</a>.  This file is a zip containing Windows packages for supported platforms.</p>

<p>To install the packages:</p>

<ul>
  <li>Open the folder that the zip was downloaded into.</li>
  <li>Right click the zip file and select Extract All...</li>
  <li>Open the folder that was created by the extraction (if it didn't open automatically).</li>
  <li>Open the folder that is appropriate for your architecture (x86 or x64).</li>
  <li>Install Rudiments...</li>
  <ul>
    <li>Open the rudiments folder.</li>
    <li>Double-click "setup".</li>
    <li>Follow the instructions in the installer.  Accept all defaults.</li>
    <li>In Windows Explorer, click the back arrow to return to the parent folder.</li>
  </ul>

  <li>Install SQL Relay...</li>
  <ul>
    <li>Open the sqlrelay folder.</li>
    <li>Double-click "setup".</li>
    <li>Follow the instructions in the installer.  Accept all defaults.</li>
  </ul>

</ul>

<p>SQL Relay should now be installed.  At this point, it's safe to delete the sqlrelay-binary-distribution-2.0.0 folder and sqlrelay-binary-distribution-2.0.0.zip file.</p>

NOTE: Rudiments and SQL Relay are currently built using Visual Studio 2013, and require the <a target="_blank" href="https://www.microsoft.com/en-us/download/details.aspx?id=40784">Visual C++ Redistributable Packages for Visual Studio 2013</a>.  Try installing this package manually if you encounter problems when trying to run SQL Relay.
</body>
</html>
